
CREATE TABLE jms_ods.yl_tms_airport_point (
  ID bigint COMMENT '经停点编码',
  LINE_ID bigint COMMENT '航线编码',
  SORT_NUM bigint COMMENT '顺序编号',
  NETWORK_ID bigint COMMENT '经停网点ID',
  NETWORK_CODE string COMMENT '经停网点编号',
  NETWORK_NAME string COMMENT '经停网点名称',
  LATEST_ARRIVAL_TIME string comment '最晚到车时间',
  LATEST_ARRIVAL_DAY bigint COMMENT '最晚到车日期' ,
  PLANNED_DEPARTURE_DATE bigint COMMENT '规划离开日期' ,
  PLANNED_DEPARTURE_TIME string COMMENT '规划离开时间',
  START_TAKE_OFF_TIME string COMMENT '起飞开始时间(HH:MM)',
  START_TAKE_OFF_DAY int COMMENT '起飞开始日期',
  END_TAKE_OFF_TIME string COMMENT '起飞结束时间(HH:MM)',
  END_TAKE_OFF_DAY int COMMENT '起飞结束日期',
  FLIGHT_SPAN_DAYS int COMMENT '航班跨天数',
  LANDING_TIME string COMMENT '落地时间(HH:MM)',
  LANDING_DAY int COMMENT '落地日期',
  SPEED int COMMENT '时速(KM/H)',
  MILEAGE int COMMENT '规划里程(KM)',
  USETIME bigint COMMENT '运输耗时(MIN)',
  PLANNED_ARRIVAL_DATE bigint COMMENT '规划到达日期',
  PLANNED_ARRIVAL_TIME string COMMENT '规划到达时间',
  STOP_TIME bigint comment '经停时长',
  HANDLING_TYPE string comment '装卸类型',
  CREATE_BY bigint COMMENT '创建人ID',
  CREATE_BY_NAME string COMMENT '创建人姓名',
  CREATE_TIME TIMESTAMP COMMENT '创建时间',
  UPDATE_BY bigint COMMENT '更新人ID',
  UPDATE_BY_NAME string COMMENT '更新人姓名',
  UPDATE_TIME TIMESTAMP COMMENT '更新时间',
  NETWORK_TYPE int COMMENT '场地类型，1：网点或转运中心，2：机场'
)COMMENT '航空线经停点'
PARTITIONED BY (
  `dt` string COMMENT '时间分区(yyyy-MM-dd)')
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  '/user/hive/dw/hive/jms_ods.db/external/yl_tms_airport_point'
tblproperties (
        'parquet.column.index.access' = 'true'
);